l108/opdracht auteurdetails/auteurinfo.php

<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Document</title> <link rel="stylesheet" type="text/css" href="infostyle.css"> </head> <body> <?php include "../db.php"; include "../functions.php"; $auteurnr = $_GET["auteurnr"]; $result = mysqli_query($db, "SELECT * FROM auteurs WHERE auteurnr = $auteurnr"); $values = mysqli_fetch_row($result); echo "<h1>$values[1] $values[3] $values[4]</h1>"; if(isset($values[6])){ echo "<p>$values[5] - $values[6]</p>"; } else{ echo "<p>$values[5]</p>"; } echo "<p>Geschreven boeken:</p>"; $result = mysqli_query($db, "SELECT * FROM boeken WHERE auteurnr = $auteurnr"); $returnedvalue = "<table>"; for($i = 0; $i < mysqli_num_rows($result); $i++){ $values = mysqli_fetch_array($result); $returnedvalue .= "<tr>"; for($j = 0; $j < count($values)/2; $j++){ if($j == 2){ $returnedvalue .= "<td><a href='boekinfo.php?boeknr=$values[0]'>$values[$j]</a></td>"; } else{ $returnedvalue .= "<td>$values[$j]</td>"; } } $returnedvalue .= "</tr>"; } $returnedvalue .= "</table>"; $returnedvalue = str_replace("<table>", "<table style='border: 1px solid'>", $returnedvalue); $returnedvalue = str_replace("<td>", "<td style='border: 1px solid'>", $returnedvalue); echo $returnedvalue; //echo formattable($result, "border"); ?> <br><span><a href="auteurs.php">Alle auteurs</a></span> </body> </html>

Resultaat

Made by Thijs Aarnoudse